/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 17:27:32
*/


-- ----------------------------
-- Table structure for tb0039
-- ----------------------------
DROP TABLE [dbo].[tb0039]
GO
CREATE TABLE [dbo].[tb0039] (
[DepartmentID] nvarchar(20) NOT NULL ,
[DepartmentName] nvarchar(100) NULL ,
[DivisionID] nvarchar(20) NOT NULL ,
[Disabled] tinyint NOT NULL DEFAULT ((0)) ,
[CreateDate] datetime NULL ,
[CreateUserID] nvarchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] nvarchar(20) NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb0039
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0039
-- ----------------------------
ALTER TABLE [dbo].[tb0039] ADD PRIMARY KEY NONCLUSTERED ([DepartmentID], [DivisionID])
GO

-- ----------------------------
-- Records of tb0039
-- ----------------------------
INSERT INTO [dbo].[tb0039] ([DepartmentID], [DepartmentName], [DivisionID], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'KHO', N'KHO', N'HPCNB2013', N'0', N'2013-01-01 09:55:23.100', N'ADMIN', N'2013-01-01 09:55:23.100', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0039] ([DepartmentID], [DepartmentName], [DivisionID], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'KETOAN', N'KẾ TOÁN', N'HPCNB2013', N'0', N'2013-01-01 09:55:33.323', N'ADMIN', N'2013-01-01 09:55:33.323', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0039] ([DepartmentID], [DepartmentName], [DivisionID], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'QUANLY', N'QUẢN LÝ', N'HPCNB2013', N'0', N'2013-01-01 09:58:13.427', N'ADMIN', N'2013-01-01 09:58:13.427', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0039] ([DepartmentID], [DepartmentName], [DivisionID], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'BANHANG', N'BÁN HÀNG', N'HPCNB2013', N'0', N'2013-01-01 09:55:43.133', N'ADMIN', N'2013-01-01 09:55:43.133', N'ADMIN')
GO
GO


